package com.cssy.xxkj.logic.dao.impl;

import java.util.List;
import java.util.Map;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.cssy.xxkj.logic.dao.ExcelExportDAO;
import com.cssy.xxkj.logic.entity.InOutBillDO;
import com.cssy.xxkj.logic.entity.vo.MiddleDataVO;
import com.plat.exception.SyBaseException;
import com.plat.helper.SearchConditions;
public class ExcelExportDAOImpl  extends SqlMapClientDaoSupport implements ExcelExportDAO {

	@Override
	public List<InOutBillDO> findOtherOutAndItemByConditions(
			SearchConditions scs) throws SyBaseException {
		List<InOutBillDO> billList = getSqlMapClientTemplate().queryForList("ExcelExport.otherOut", scs);
		return billList;
	}

	@Override
	public List<InOutBillDO> findOtherInAndItemByConditions(
			SearchConditions scs) throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.otherIn", scs);
	}

	@Override
	public List<InOutBillDO> findPurchasewareInAndItemByConditions(
			SearchConditions scs) throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.purchaseWareIn", scs);
	}

	@Override
	public List<InOutBillDO> findSotrageInAndItemByConditions(
			SearchConditions scs) throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.productionStorageIn", scs);
	}

	@Override
	public List<InOutBillDO> findstorageOutAndItemByConditions(
			SearchConditions scs) throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.productionStorageOut", scs);
	}

	@Override
	public List<InOutBillDO> findMaterialOutAndItemByConditions(
			SearchConditions scs) throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.materialOut", scs);
	}

	@Override
	public List<InOutBillDO> findAllocationtAndItemByConditions(
			SearchConditions scs) throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.allAction", scs);
	}

	@Override
	public List<InOutBillDO> findBatchInAndItemByConditions(SearchConditions scs)
			throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.batchIn", scs);
	}

	@Override
	public List<InOutBillDO> findPDByConditions(SearchConditions scs)
			throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("ExcelExport.pd", scs);
	}

	@SuppressWarnings("unchecked")
	@Override
	public List<MiddleDataVO> findMDVBy(Map<String, Object> paramMap)
			throws SyBaseException {
		return getSqlMapClientTemplate().queryForList("LogicWarehouseDetails_ex.findDetailsDO", paramMap);
	}


}
